Discover used command not allowed with mysql version, include the articles, news, trends, analysis and practical advice about used command not allowed with mysql version on alibabacloud.com
Purpose: To import a. txt file to the MySQL database, using the load command to implementEnter the following command to error:Modify the command, still error:Possible causes (from MySQL reference manual):If LOAD DATA localis Disabled, either in the
Mysql remote connection: ERROR 1130 (HY000): Host '*. *' is not allowed to connect to this MySQL server, mysqlconnect
After MySQL is installed, ERROR 1130 (HY000): host' 192 occurs when you remotely connect to the database. 168.0.1 'is not allowed
1. download MySql
1. download MySql
Open http://www.mysql.com/downloads/mysql/#downloads download in browser
My downloaded version is Red Hat 5 version of http://www.mysql.com/downloads/mirror.php? Id = 407552
Upload the file to the server, or
Mysql common command lines
Mysql common command lines
First, start and stop the mysql Service
Net stop mysql
Net start mysql
Second, log on to mysql
Syntax: mysql-u user name-p User Password
Enter the mysql-uroot-p command, press enter and prompt
first, start and exit
1, into MySQL: Start the MySQL Command line Client (MySQL's DOS interface), directly enter the installation of the password can be. The prompt at this point is:mysql>
2, Exit Mysql:quit or exit
Second, the library operation1.
1. Export the entire database
Mysqldump-u user name-p--default-character-set=latin1 Database name > exported file name (database default encoding is latin1)
Mysqldump-u wcnc-p SMGP_APPS_WCNC > Wcnc.sql
2. Export a table
Mysqldump-u user name-P
I originally wanted to build the Hive remote mode and found that there are no other databases except oracle and sybase on the machine. I want to dress up with a mysql instance. I plan to install mysql on the host Win7, and then place the Hive
If you want to do a Java EE development on Linux, first build the Java EE development environment, including the JDK, Tomcat, Eclipse installation (this in a previous essay has explained in detail the Linux learning CentOS (vii)- CentOS under the
1. Download the MySQL Installation FileThe following two files are required to install MYSQL:MySQL-server-4.0.23-0.i386.rpmMySQL-client-4.0.23-0.i386.rpmTo: http://www.mysql.com/downloads/mysql-4.0.html, open this webpage and pull down the webpage
Website:Program on:Web server 192.168.1.100 abovedatabase in: MySQL server 192.168.1.123 aboveImplementation Purpose: add a MySQL backup server (192.168.1.124), as a MySQL server (192.168.1.123) from the server, the two MySQL servers to achieve dual-
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.